package com.weixin.dao;

import java.sql.SQLException;
import java.util.List;

import com.weixin.entity.Student;
import com.weixin.entity.User;

public interface StudentDao {
        public List<Student> selsctAll() throws SQLException;
        public Student selectByid(int s_id) throws SQLException;
        public boolean deleteByid(int u_id) throws SQLException;
        public boolean insert(Student student) throws SQLException;
        public boolean update(Student student) throws SQLException;
        public Student selsctByName(String name) throws SQLException;
        public List<User> getAllBypage(String role,int pageNum,int pageSize) throws SQLException;
        public int getTotal(String role) throws SQLException;
        public User select(String name,String password) throws SQLException;
        public List<User> ListByrole(String role) throws SQLException;
        public boolean deleteByRole(int u_id) throws SQLException;
        public boolean deleteByAll(List<String> u_ids) throws SQLException;
        public boolean deleteByRoleAll(List<String> u_ids) throws SQLException;
        public List<User> selectSearch(String role,String search,int pageNum,int pageSize) throws SQLException;
        public int selectTotalSearch(String role,String search) throws SQLException;
        
}
